How to Add Paper Size in Excel (4 Easy Ways) |
您所在的位置:网站首页 › custom page sizing in word 365 › How to Add Paper Size in Excel (4 Easy Ways) |
Get FREE Advanced Excel Exercises with Solutions!
Adding paper size in Excel is needed when you want to print your Excel sheet. In this article, I will explain how to add paper size in Excel. I will explain 4 different ways of doing it. Table of Contents hide Download Practice Workbook 4 Easy Ways to Add Paper Size in Excel 1. Using the Page Layout Tab to Add Paper Size in Excel 2. Use of Print Option to Add Paper Size in Excel 3. Employing Page Setup Feature to Add Paper Size in Excel 4. Adding Custom Paper Size 💬 Things to Remember Practice Section Conclusion Related Articles Download Practice Workbook Adding Paper Size.xlsx 4 Easy Ways to Add Paper Size in ExcelHere, I have taken the following dataset to explain this article. The dataset contains a Sales Overview. In this method, I will explain how to add paper size in Excel using the Page Layout tab. Let’s see the steps. Steps: Firstly, go to the Page Layout tab from the Ribbon. Secondly, select Size.A drop-down menu will appear. Now, select the Page Size you want from the drop-down menu. Here, I selected A5.Now, you will be able to see the Print Preview. Here, you can see how the page will look on the selected Page Size after printing. Read More: How to Print Full Page of Excel Sheet in A4 Size (5 Simple Ways) 2. Use of Print Option to Add Paper Size in ExcelIn this method, I will explain how you can add Paper Size in Excel by the use of the Print option. Let’s see the steps. Steps: Firstly, go to the File tab.Now, a drop-down menu will appear. Next, select the Page Size you want. Here, I selected Statement.Here, in the Print Preview, you can see how the page will look on the selected Page Size after printing. Read More: How to Adjust Page Size for Printing in Excel (6 Quick Tricks) Similar Readings How to Fit All Columns on One Page in Excel (5 Easy Methods) Change the Printing Scale So All Columns Will Print on a Single Page How to Add Legal Paper Size in Excel Excel Fit to Page Scale/Preview Looks Small (5 Suitable Solutions) 3. Employing Page Setup Feature to Add Paper Size in ExcelIn this method, I will explain how you can employ the Page Setup feature to add Paper size in Excel. Let’s see the steps. Steps: Firstly, go to the Page Layout tab. Secondly, select the dialog box option from Page Setup.Now, you will see the dialog box named Page Setup. Firstly, go to the Page tab. Secondly, select the drop-down button from Paper size.Here, a drop-down menu will appear. Next, select the Paper size you want from the drop-down menu. Here, I selected A3.Now, in the Print Preview, you can see how the page will look on the selected Page Size after printing. Read More: How to Add A3 Paper Size in Excel (2 Quick Ways) 4. Adding Custom Paper SizeIn this method, I will explain how you can add a custom Paper Size. Let’s see the steps. Steps: Firstly, search for Printers & scanners in your Windows Search. Secondly, select Printers & scanners.Now, your Printers & scanners settings will open. After that, select your printer. Here, I selected my printer which is HP LaserJet Pro M12w.Now, you will get a dialog box. Next, select Custom to make a custom size.Custom Paper Size dialog box will appear. Firstly, write the Name for your custom size. Secondly, select the Width. Thirdly, select the Height. Finally, select Save.Now, go to your Excel file. Firstly, select the File tab.Now, a drop-down menu will appear. Next, select the custom Page Size you want. Here, I selected new size (which I created earlier).Here, in the Print Preview, you can see how the page will look on the selected Page Size after printing. Read More: Why Is My Excel Sheet Printing So Small (Reasons and Solutions) 💬 Things to Remember It should be noted that the custom page size is not a feature of Excel. To customize the paper size you will need a Printer connected to your device. Practice SectionHere, I have provided a practice sheet for you to practice how to add paper size in Excel. To conclude, I tried to explain how to add page size in Excel in this article. I covered 4 different methods of doing it. I hope this was helpful for you. To get more articles like this visit ExcelDemy. Lastly, if you have any questions, feel free to let me know in the comment section below. Related Articles [Solved!] Print Scale to Fit Not Working in Excel How to Fit Excel Sheet on One Page PDF (8 Simple Ways) Fit to Page in Excel (3 Easy Ways) How to Fit Excel Sheet on One Page in Word (3 Simple Ways) Stretch Excel Spreadsheet to Full Page Print (5 Easy Ways) SaveSavedRemoved 0Tags: Print Scale Excel Hey! Welcome to my profile. Currently, I am doing research on Microsoft Excel. I will be posting articles related to this here. My last educational degree was B.Sc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. I like to explore new things and find the best and most innovative solutions in every situation. Related Articles Added to wishlistRemoved from wishlist 0 ![]() ![]() ![]() ![]() |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |